ALTER PROC [dbo].[SP_INSERT_THUE_PHONG]
@MA_PHONG INT, 
@NGAY_THUE DATE, 
@TIEN_COC FLOAT, 
@USER_ID INT,
@retval NVARCHAR(10) OUTPUT
AS
BEGIN
	DECLARE @ID_RETURN INT
	INSERT INTO 
	dbo.THUE_PHONG
	(
		MA_PHONG,
		NGAY_THUE,
		TIEN_COC,
		CREATE_BY,
		UPDATE_BY,
		CREATE_AT,
		UPDATE_AT,
		ACTIVE
	)
	VALUES
	(
		@MA_PHONG,
		@NGAY_THUE,
		@TIEN_COC,
		@USER_ID,
		@USER_ID,
		GETDATE(), 
		GETDATE(),
		'A'		
	);
	SET @ID_RETURN = (SELECT SCOPE_IDENTITY());
	SET @retval = CONVERT(Nvarchar(10), @ID_RETURN);
END